C:/Projekte/RAIS/dataaccesslayertest/CommonClasses/FieldTest.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;
using System.Text;
using NUnit.Framework;
using RAIS.Common.TableManagement;
using RAIS.DataAccessLayer;

namespace RAIS.DataAccessLayerTest.CommonClasses
{
        [TestFixture]
        public class FieldTest
        {
                Field.FieldTypeData fieldTypeData;
                Field.FieldSizeData fieldSizeData;
                Field.NecessityTypeData necessityTypeData;

                [SetUp]
                public void Init()
                {
                        // The fieldTypesDictionary field is initialized in TableManagement 
                        // static constructor, so, create new TableManagement object to 
                        // initialize fieldTypesDictionary field.
                        TableManagement tableManagement = new TableManagement();

                        this.fieldTypeData = new Field.FieldTypeData();
                        this.fieldSizeData = new Field.FieldSizeData();
                        this.necessityTypeData = new Field.NecessityTypeData();
                }
                [Test]
                public void FieldTypesDictionary_Count()
                {
                        // Preparations
                        int expectedCount = 7;

                        // Test 
                        Assert.AreEqual(expectedCount, Field.FieldTypesDictionary.Count);
                }
                [Test]
                public void FieldTypesDictionary_Text()
                {
                        // Preparations
                        int expectedID = 1;
                        Field.FieldType expectedType = Field.FieldType.Text;
                        string expectedVisibleName = "Text";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_Date()
                {
                        // Preparations
                        int expectedID = 2;
                        Field.FieldType expectedType = Field.FieldType.Date;
                        string expectedVisibleName = "Date";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_Numeric()
                {
                        // Preparations
                        int expectedID = 3;
                        Field.FieldType expectedType = Field.FieldType.Numeric;
                        string expectedVisibleName = "Numeric";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_SingleLookup()
                {
                        // Preparations
                        int expectedID = 4;
                        Field.FieldType expectedType = Field.FieldType.SingleLookup;
                        string expectedVisibleName = "Single Lookup";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_MultipleLookup()
                {
                        // Preparations
                        int expectedID = 5;
                        Field.FieldType expectedType = Field.FieldType.MultipleLookup;
                        string expectedVisibleName = "Multiple Lookup";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_LookupPlusIntegerValue()
                {
                        // Preparations
                        int expectedID = 6;
                        Field.FieldType expectedType = Field.FieldType.LookupPlusIntegerValue;
                        string expectedVisibleName = "Lookup Plus Integer Value";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }
                [Test]
                public void FieldTypesDictionary_LookupPlusScientificValue()
                {
                        // Preparations
                        int expectedID = 7;
                        Field.FieldType expectedType = Field.FieldType.LookupPlusScientificValue;
                        string expectedVisibleName = "Lookup Plus Scientific Value";

                        // Test
                        this.fieldTypeData = Field.FieldTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldTypeData.ID);
                        Assert.AreEqual(expectedType, this.fieldTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldTypeData.VisibleName);
                }

                [Test]
                public void FieldSizesDictionary_Count()
                {
                        // Preparations
                        int expectedCount = 9;

                        // Test 
                        Assert.AreEqual(expectedCount, Field.FieldSizesDictionary.Count);
                }
                [Test]
                public void FieldSizesDictionary_Large()
                {
                        // Preparations
                        int expectedID = 1;
                        Field.FieldSize expectedSize = Field.FieldSize.Large;
                        string expectedVisibleName = "Large (below 256 chars)";
                        Field.FieldType expectedFieldType = Field.FieldType.Text;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Medium()
                {
                        // Preparations
                        int expectedID = 2;
                        Field.FieldSize expectedSize = Field.FieldSize.Medium;
                        string expectedVisibleName = "Medium (below 128 chars)";
                        Field.FieldType expectedFieldType = Field.FieldType.Text;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Memo()
                {
                        // Preparations
                        int expectedID = 3;
                        Field.FieldSize expectedSize = Field.FieldSize.Memo;
                        string expectedVisibleName = "Memo (more then 255 chars)";
                        Field.FieldType expectedFieldType = Field.FieldType.Text;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Small()
                {
                        // Preparations
                        int expectedID = 4;
                        Field.FieldSize expectedSize = Field.FieldSize.Small;
                        string expectedVisibleName = "Small (below 50 chars)";
                        Field.FieldType expectedFieldType = Field.FieldType.Text;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Integer()
                {
                        // Preparations
                        int expectedID = 5;
                        Field.FieldSize expectedSize = Field.FieldSize.Integer;
                        string expectedVisibleName = "Integer (-2; -1; 0; 1; 2...)";
                        Field.FieldType expectedFieldType = Field.FieldType.Numeric;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Rational()
                {
                        // Preparations
                        int expectedID = 6;
                        Field.FieldSize expectedSize = Field.FieldSize.Rational;
                        string expectedVisibleName = "Rational (-2.5; 0.0; 2.5)";
                        Field.FieldType expectedFieldType = Field.FieldType.Numeric;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Scientific()
                {
                        // Preparations
                        int expectedID = 7;
                        Field.FieldSize expectedSize = Field.FieldSize.Scientific;
                        string expectedVisibleName = "Scientific Number";
                        Field.FieldType expectedFieldType = Field.FieldType.Numeric;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_TimeInterval()
                {
                        // Preparations
                        int expectedID = 8;
                        Field.FieldSize expectedSize = Field.FieldSize.TimeInterval;
                        string expectedVisibleName = "Time Interval";
                        Field.FieldType expectedFieldType = Field.FieldType.Numeric;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }
                [Test]
                public void FieldSizesDictionary_Year()
                {
                        // Preparations
                        int expectedID = 9;
                        Field.FieldSize expectedSize = Field.FieldSize.Year;
                        string expectedVisibleName = "Year";
                        Field.FieldType expectedFieldType = Field.FieldType.Numeric;

                        // Test
                        this.fieldSizeData = Field.FieldSizesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.fieldSizeData.ID);
                        Assert.AreEqual(expectedSize, this.fieldSizeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.fieldSizeData.VisibleName);
                        Assert.AreEqual(expectedFieldType, this.fieldSizeData.FieldType);
                }

                [Test]
                public void NecessityTypesDictionary_Count()
                {
                        // Preparations
                        int expectedCount = 3;

                        // Test 
                        Assert.AreEqual(expectedCount, Field.NecessityTypesDictionary.Count);
                }
                [Test]
                public void NecessityTypesDictionary_Required()
                {
                        // Preparations
                        int expectedID = 1;
                        Field.NecessityType expectedType = Field.NecessityType.Required;
                        string expectedVisibleName = "Required";

                        // Test
                        this.necessityTypeData = Field.NecessityTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.necessityTypeData.ID);
                        Assert.AreEqual(expectedType, this.necessityTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.necessityTypeData.VisibleName);
                }
                [Test]
                public void NecessityTypesDictionary_Suggested()
                {
                        // Preparations
                        int expectedID = 2;
                        Field.NecessityType expectedType = Field.NecessityType.Suggested;
                        string expectedVisibleName = "Suggested";

                        // Test
                        this.necessityTypeData = Field.NecessityTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.necessityTypeData.ID);
                        Assert.AreEqual(expectedType, this.necessityTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.necessityTypeData.VisibleName);
                }
                [Test]
                public void NecessityTypesDictionary_NotRequired()
                {
                        // Preparations
                        int expectedID = 3;
                        Field.NecessityType expectedType = Field.NecessityType.NotRequired;
                        string expectedVisibleName = "Not Required";

                        // Test
                        this.necessityTypeData = Field.NecessityTypesDictionary[expectedVisibleName];

                        // Checks
                        Assert.AreEqual(expectedID, this.necessityTypeData.ID);
                        Assert.AreEqual(expectedType, this.necessityTypeData.Type);
                        Assert.AreEqual(expectedVisibleName, this.necessityTypeData.VisibleName);
                }
        }
}